package org.jix.weblog.module.common.domain.mapper;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.jix.weblog.module.common.domain.dos.TagDO;

import java.time.LocalDate;
import java.util.List;
import java.util.Objects;

/**
 * @version 1.0
 * @Author Jix
 * @Date 2024/7/30 9:40
 * @注释
 */


public interface TagMapper extends BaseMapper<TagDO> {

    /**
     * 分页查询
     * @param
     * @return
     */
    default Page<TagDO> selectPageList(
            long current,
            long size,
            String name,
            LocalDate startDate,
            LocalDate endDate) {
        //分页对象
        Page<TagDO> page = new Page<TagDO>(current, size);
        //构建查询条件
        LambdaQueryWrapper<TagDO> wrapper = new LambdaQueryWrapper<>();
        wrapper.like(Objects.nonNull(name),TagDO::getName, name)
                .ge(Objects.nonNull(startDate),TagDO::getCreateTime, startDate)
                .le(Objects.nonNull(endDate),TagDO::getCreateTime, endDate)
                .orderByDesc(TagDO::getCreateTime);// order by create_time desc
        return selectPage(page,wrapper);
    }

    /**
     *根据标签模糊查询
     * @param key
     * @return
     */
    default List<TagDO> selectByKey(String key) {
        LambdaQueryWrapper<TagDO> wrapper = new LambdaQueryWrapper<>();
        //构建查询条件
        wrapper.like(TagDO::getName, key).orderByDesc(TagDO::getCreateTime);
        //返回查询结果
        return selectList(wrapper);
    }

    /**
     * 根据标签 ID 批量查询
     * @param tagIds
     * @return
     */
    default List<TagDO> selectByIds(List<Long> tagIds) {

        return selectList(Wrappers.<TagDO>lambdaQuery().in(TagDO::getId, tagIds));
    }
}
